<?php

    /**
    * This is the model class for table "manager_update_bill".
    *
    * The followings are the available columns in table 'manager_update_bill':
    * @property string $id
    * @property string $bill_id
    * @property string $status_pay
    * @property string $status_do
    * @property string $status_return
    * @property string $status
    * @property string $manager_id
    * @property string $created
    *
    * The followings are the available model relations:
    * @property Bill $bill
    * @property Manager $manager
    */
    class ManagerUpdateBill extends Model
    {
        /**
        * Returns the static model of the specified AR class.
        * @param string $className active record class name.
        * @return ManagerUpdateBill the static model class
        */
        public static function model($className=__CLASS__)
        {
            return parent::model($className);
        }

        /**
        * @return string the associated database table name
        */
        public function tableName()
        {
            return 'manager_update_bill';
        }

        /**
        * @return array validation rules for model attributes.
        */
        public function rules()
        {
            // NOTE: you should only define rules for those attributes that
            // will receive user inputs.
            return array(
                array('bill_id, manager_id, created', 'required'),
                array('bill_id, manager_id, created', 'length', 'max'=>10),

                array('status_pay, status_do, status_return, status', 'match', 'pattern' => '/^(PAID|UNPAID|PENDING|PROCESSING|COMPLETED|YES|NO|CANCEL)$/', 'message' => 'Trạng thái đơn hàng không hợp lệ'),

                // The following rule is used by search().
                // Please remove those attributes that should not be searched.
                array('id, bill_id, manager_id, created', 'safe', 'on'=>'search'),
            );
        }

        /**
        * @return array relational rules.
        */
        public function relations()
        {
            // NOTE: you may need to adjust the relation name and the related
            // class name for the relations automatically generated below.
            return array(
                'bill' => array(self::BELONGS_TO, 'Bill', 'bill_id'),
                'manager' => array(self::BELONGS_TO, 'Manager', 'manager_id'),
            );
        }

        /**
        * @return array customized attribute labels (name=>label)
        */
        public function attributeLabels()
        {
            return array(
                'id' => 'ID',
                'bill_id' => 'Bill',
                'bill_status' => 'Bill Status',
                'manager_id' => 'Manager',
                'created' => 'Created',
            );
        }

        /**
        * Retrieves a list of models based on the current search/filter conditions.
        * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
        */
        public function search()
        {
            // Warning: Please modify the following code to remove attributes that
            // should not be searched.

            $criteria=new CDbCriteria;

            $criteria->compare('id',$this->id,true);
            $criteria->compare('bill_id',$this->bill_id,true);
            $criteria->compare('bill_status',$this->bill_status,true);
            $criteria->compare('manager_id',$this->manager_id,true);
            $criteria->compare('created',$this->created,true);

            return new CActiveDataProvider($this, array(
                'criteria'=>$criteria,
            ));
        }

        
        public function getCreatedTime(){
            return Yii::app()->dateFormatter->formatDateTime($this->created, 'short', 'short');
        }
}